package com.bgIntlgn.client.entity.warehourse;

import yuhuibear.poat.annotations.relation.View;
import yuhuibear.poat.object.bean.Bean;

/**
 * uid的库存数量与上下限
 * 
 * @author Simon Chen
 * 
 */
@View(name = "uid_stock_and_limit", sqlToCreate = "select us.uid as uid, us.quantity  as quantity, "
		+ "sl.lower_limit as lowerlimit, sl.upper_limit as upperlimit "
		+ "from (select bill.uid as uid, sum(bill.quantity)  as quantity from storage_bill_records as bill"
		+ " group by bill.uid) as us left outer join storage_limits as sl on us.uid = sl.uid")
public class UidStockandLimit implements Bean {

	private String uid;
	private Long quantity;
	private Integer lowerlimit;
	private Integer upperlimit;

	public String getUid() {
		return uid;
	}

	public void setUid(String uid) {
		this.uid = uid;
	}

	public Long getQuantity() {
		return quantity;
	}

	public void setQuantity(Long quantity) {
		this.quantity = quantity;
	}

	public Integer getLowerlimit() {
		return lowerlimit;
	}

	public void setLowerlimit(Integer lowerlimit) {
		this.lowerlimit = lowerlimit;
	}

	public Integer getUpperlimit() {
		return upperlimit;
	}

	public void setUpperlimit(Integer upperlimit) {
		this.upperlimit = upperlimit;
	}
}
